ItemSalesProhibitionPeriodRule

Entity Definition

Logical Name : ItemSalesProhibitionPeriodRule
Physical Name : RU_PRD_ITM_SLS_PRH

A rule that identifies specific days of the week and/or special dates and time periods during which the sale of an ITEM is prohibited.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
SalesRestrictionTypeCode (FK)(PK) A unique, automatically assigned code for a specific limitation on an ITEM's sale. TY_RST_SLS Code4 char(4)
TimeGroupID (FK) A unique identifier for a set of consecutive hours on a set of days of the week. e.g. 10am - 2pm Mon, Wed and Fri. ID_GP_TM Identity integer TimeGroup(CO_GP_TM)
StartDayOfWeekCode A code to denote the start date in the week for the item sales restriction. WD_SRT_RST DateWeekdayISO8061 char(1)
EndDayOfWeekCode A code to denote the end date in the week for the item sales restriction. WD_END_RST DateFiscalDay char(1)
StartTime A code to denote the start time on a specified day for the item sales restriction. TM_SRT_RST Time Time
EndTime A code to denote the end time on a specified day for the item sales restriction. TM_END_RST Time Time

Relationships

Parent Entity Verb Phrase Child Entity
TimeGroup defines ItemSalesProhibitionPeriodRule
SalesRestriction can be a ItemSalesProhibitionPeriodRule

Logical Views containing ItemSalesProhibitionPeriodRule

Logical View
Logical 01000 - Item Description - Macro View
Logical 01004 - Item Description - Branding
Logical 01100 - Item Selling Rules - Macro View
Logical 01110 - Item Selling Rules - Restrictions View
Logical 02350 - Retail Transaction - Restriction Validation View
Logical 06500 - Time Groups View